package com.qf.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qf.pojo.DtsCategory;
import com.qf.vo.CatVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 类目表 Mapper 接口
 * </p>
 *
 * @author zhaojian
 * @since 2021-05-12
 */
public interface DtsCategoryMapper extends BaseMapper<DtsCategory> {


    /**
     * 查询一级目录
     * @return
     */
    @Select(" select id as value,name as label  from dts_category where deleted=0 and pid !=0  ")
    public List<CatVo> selectDtsCategory();


    /**
     * 查询二级目录
     * @return
     */
    @Select("select id as value,name as label \n" +
            "from dts_category a\n" +
            "where a.pid=0 and deleted=0")
    public List<CatVo> selectDtsCat();
}
